Re: concurrent cursors possible with portals?

Поиск
Список
Период
Сортировка
От M. Bastin
Тема Re: concurrent cursors possible with portals?
Дата
Msg-id a0610051bbd09f712f42c@[213.224.114.176]
обсуждение исходный текст
Ответ на function accessing other db  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
Список pgsql-novice
>"M. Bastin" <marcbastin@mindspring.com> writes:
>>  I'm reading the docs about the extended query language and the
>>  portals.  Is it possible to use portals as a kind of concurrent
>>  cursors over a single TCP/IP connection?
>>  Or should you execute and close portals one after another and never
>>  execute the next portal before the previous one is closed?  (Like
>>  regular transactions.)
>
>You can certainly have multiple portals open and fetch from different
>ones in turn; not clear if that's what you meant.

Yes, I was thinking about a threaded client that would be able to
fetch from several portals (quasi) simultaneously and repeatedly (but
with other parameters) over 1 TCP/IP connection.

The only thing that bothers me is the Sync command that would put an
end to all portals at once isn't it?  The docs seem to say you need
to issue a sync after each cycle.  There doesn't seem to be a
possibility to selectively keep some portals open this way.

That's what I make from reading the docs, I haven't had the chance to
actually experiment with it yet.  (I'm in the process of implementing
the frontend-backend protocol v3 for my IDE.  Only after that can I
start experimenting.)

Marc

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: .pgpass
Следующее
От: Tom Lane
Дата:
Сообщение: Re: concurrent cursors possible with portals?